﻿CREATE TABLE [dbo].[AW_DocTakeUpSale] (
    [DocSaleId]            UNIQUEIDENTIFIER NULL,
    [DocSaleTitle]         NVARCHAR (250)   NULL,
    [DocOpenRefNo]         NVARCHAR (250)   NULL,
    [TransactionId]        UNIQUEIDENTIFIER NULL,
    [Category]             NVARCHAR (50)    NULL,
    [REN]                  NVARCHAR (500)   NULL,
    [Lister]               NVARCHAR (500)   NULL,
    [DocDate]              DATETIME         NULL,
    [Premise]              NVARCHAR (500)   NULL,
    [TransactedPrice]      DECIMAL (18, 2)  NULL,
    [BalMonthChar]         NVARCHAR (50)    NULL,
    [BalMonthInt]          DECIMAL (18, 2)  NULL,
    [ModeOfPayment]        NVARCHAR (50)    NULL,
    [ExMonthChar]          NVARCHAR (50)    NULL,
    [ExMonthInt]           DECIMAL (18, 2)  NULL,
    [WInterest]            NVARCHAR (50)    NULL,
    [Interest]             DECIMAL (18, 2)  NULL,
    [SPADate]              DATETIME         NULL,
    [Remarks]              NVARCHAR (MAX)   NULL,
    [VendorName]           NVARCHAR (500)   NULL,
    [VendorNRIC]           NVARCHAR (250)   NULL,
    [VendorAddress]        NVARCHAR (500)   NULL,
    [VendorContactPerson]  NVARCHAR (250)   NULL,
    [VendorTel]            NVARCHAR (250)   NULL,
    [VendorFax]            NVARCHAR (250)   NULL,
    [VendorMobile]         NVARCHAR (250)   NULL,
    [VendorComission]      DECIMAL (18, 2)  NULL,
    [VendorSCompany]       NVARCHAR (250)   NULL,
    [VendorSAddress]       NVARCHAR (500)   NULL,
    [VendorSContactPerson] NVARCHAR (250)   NULL,
    [VendorSTel]           NVARCHAR (250)   NULL,
    [VendorSFax]           NVARCHAR (250)   NULL,
    [VendorSMobile]        NVARCHAR (250)   NULL,
    [PurcName]             NVARCHAR (500)   NULL,
    [PurcNRIC]             NVARCHAR (250)   NULL,
    [PurcAddress]          NVARCHAR (500)   NULL,
    [PurcContactPerson]    NVARCHAR (250)   NULL,
    [PurcTel]              NVARCHAR (250)   NULL,
    [PurcFax]              NVARCHAR (250)   NULL,
    [PurcMobile]           NVARCHAR (250)   NULL,
    [PurcDisbursement]     DECIMAL (18, 2)  NULL,
    [PurcSCompany]         NVARCHAR (250)   NULL,
    [PurcSAddress]         NVARCHAR (500)   NULL,
    [PurcSContactPerson]   NVARCHAR (250)   NULL,
    [PurcSTel]             NVARCHAR (250)   NULL,
    [PurcSFax]             NVARCHAR (250)   NULL,
    [PurcSMobile]          NVARCHAR (250)   NULL,
    [OtherRemarks]         NVARCHAR (MAX)   NULL,
    [CreateDate]           DATETIME         NULL,
    [CreateBy]             UNIQUEIDENTIFIER NULL,
    [UpdateDate]           DATETIME         NULL,
    [UpdateBy]             UNIQUEIDENTIFIER NULL,
    [StatusDelete]         TINYINT          NULL
);

